clients

Dataset statistics

Number of variables	13
Number of observations	2968
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.6 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `q_invoices` and 4 other fields	High correlation
`recency_days` is highly correlated with `q_invoices`	High correlation
`q_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`q_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`q_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `q_returns` and 1 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_basket_size`	High correlation
`q_returns` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 25.15706781)	Skewed
`frequency` is highly skewed (γ1 = 24.87675009)	Skewed
`q_returns` is highly skewed (γ1 = 21.9754032)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 33 (1.1%) zeros	Zeros
`q_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2022-11-12 21:23:55.351230
Analysis finished	2022-11-12 21:24:16.634723
Duration	21.28 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2968
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2316.666442

Minimum	0
Maximum	5714
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.35
Q1	928.5
median	2119.5
Q3	3536.25
95-th percentile	5034.3
Maximum	5714
Range	5714
Interquartile range (IQR)	2607.75

Descriptive statistics

Standard deviation	1554.722712
Coefficient of variation (CV)	0.6711033938
Kurtosis	-1.010637904
Mean	2316.666442
Median Absolute Deviation (MAD)	1270.5
Skewness	0.3426249769
Sum	6875866
Variance	2417162.71
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3010	1	< 0.1%
2995	1	< 0.1%
2996	1	< 0.1%
2999	1	< 0.1%
3000	1	< 0.1%
3001	1	< 0.1%
3002	1	< 0.1%
3005	1	< 0.1%
3007	1	< 0.1%
Other values (2958)	2958	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5714	1	< 0.1%
5695	1	< 0.1%
5685	1	< 0.1%
5679	1	< 0.1%
5658	1	< 0.1%
5654	1	< 0.1%
5648	1	< 0.1%
5637	1	< 0.1%
5636	1	< 0.1%
5626	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2968
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.37702

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.35
Q1	13798.75
median	15220.5
Q3	16768.5
95-th percentile	17964.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.144523
Coefficient of variation (CV)	0.1125803587
Kurtosis	-1.206178196
Mean	15270.37702
Median Absolute Deviation (MAD)	1489
Skewness	0.03219371129
Sum	45322479
Variance	2955457.892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
12670	1	< 0.1%
17734	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
Other values (2958)	2958	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2953
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2693.389373

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.7325
Q1	570.845
median	1085.51
Q3	2306.905
95-th percentile	7169.562
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1736.06

Descriptive statistics

Standard deviation	10135.32607
Coefficient of variation (CV)	3.763037818
Kurtosis	397.3184084
Mean	2693.389373
Median Absolute Deviation (MAD)	671.39
Skewness	17.63574461
Sum	7993979.66
Variance	102724834.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.96	2	0.1%
2053.02	2	0.1%
331	2	0.1%
1353.74	2	0.1%
889.93	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
731.9	2	0.1%
734.94	2	0.1%
Other values (2943)	2948	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65019.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.31030997

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.76031378
Coefficient of variation (CV)	1.209142264
Kurtosis	2.77659321
Mean	64.31030997
Median Absolute Deviation (MAD)	26
Skewness	1.79807024
Sum	190873
Variance	6046.666399
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2218	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

q_invoices
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.724056604

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.857882575
Coefficient of variation (CV)	1.5474834
Kurtosis	190.7771511
Mean	5.724056604
Median Absolute Deviation (MAD)	2
Skewness	10.76520644
Sum	16989
Variance	78.46208371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.4%
3	498	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	785	26.4%
3	498	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

q_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1664
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1579.712264

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	101.35
Q1	296
median	638
Q3	1398.25
95-th percentile	4403.25
Maximum	196844
Range	196843
Interquartile range (IQR)	1102.25

Descriptive statistics

Standard deviation	5700.529956
Coefficient of variation (CV)	3.608587516
Kurtosis	518.1228414
Mean	1579.712264
Median Absolute Deviation (MAD)	419
Skewness	18.7602581
Sum	4688586
Variance	32496041.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
260	8	0.3%
84	8	0.3%
288	8	0.3%
272	8	0.3%
246	8	0.3%
516	7	0.2%
394	7	0.2%
Other values (1654)	2885	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%
50255	1	< 0.1%

q_products
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	469
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.7456199

Minimum	1
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7837
Range	7836
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.8785162
Coefficient of variation (CV)	2.198681439
Kurtosis	354.7550751
Mean	122.7456199
Median Absolute Deviation (MAD)	44
Skewness	15.70464041
Sum	364309
Variance	72834.41353
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	45	1.5%
20	38	1.3%
35	35	1.2%
15	33	1.1%
29	33	1.1%
19	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	29	1.0%
Other values (459)	2629	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	15	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	27	0.9%
10	27	0.9%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2965
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.99655282

Minimum	2.150588235
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.915887985
Q1	13.11811111
median	17.96548505
Q3	24.98179365
95-th percentile	90.052125
Maximum	4453.43
Range	4451.279412
Interquartile range (IQR)	11.86368254

Descriptive statistics

Standard deviation	119.5318165
Coefficient of variation (CV)	3.622554671
Kurtosis	812.969606
Mean	32.99655282
Median Absolute Deviation (MAD)	5.980669355
Skewness	25.15706781
Sum	97933.76878
Variance	14287.85517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	2	0.1%
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
13.92736842	1	< 0.1%
36.24411765	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
Other values (2955)	2955	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.30505288

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.9271978
median	48.26785714
Q3	85.33333333
95-th percentile	200.65
Maximum	366
Range	365
Interquartile range (IQR)	59.40613553

Descriptive statistics

Standard deviation	63.50325927
Coefficient of variation (CV)	0.9435139941
Kurtosis	4.908645262
Mean	67.30505288
Median Absolute Deviation (MAD)	26.26785714
Skewness	2.06622239
Sum	199761.397
Variance	4032.663938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
11	17	0.6%
46	17	0.6%
21	17	0.6%
28	16	0.5%
Other values (1248)	2776	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1138262908

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008893504781
Q1	0.01633986928
median	0.02589835169
Q3	0.04942659085
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.03308672157

Descriptive statistics

Standard deviation	0.4082214549
Coefficient of variation (CV)	3.586354717
Kurtosis	989.0590635
Mean	0.1138262908
Median Absolute Deviation (MAD)	0.0121968864
Skewness	24.87675009
Sum	337.8364311
Variance	0.1666447562
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.02777777778	17	0.6%
0.0625	17	0.6%
0.02380952381	16	0.5%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.03571428571	13	0.4%
0.07692307692	13	0.4%
Other values (1215)	2636	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

q_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	213
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.88847709

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	282.864784
Coefficient of variation (CV)	8.107685048
Kurtosis	596.2019916
Mean	34.88847709
Median Absolute Deviation (MAD)	1
Skewness	21.9754032
Sum	103549
Variance	80012.48604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
7	43	1.4%
8	43	1.4%
Other values (203)	705	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	148	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1972
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	235.7885065

Minimum	1
Maximum	6009.333333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2375
median	172
Q3	281.375
95-th percentile	598.345
Maximum	6009.333333
Range	6008.333333
Interquartile range (IQR)	178.1375

Descriptive statistics

Standard deviation	283.7237528
Coefficient of variation (CV)	1.203297637
Kurtosis	103.0742725
Mean	235.7885065
Median Absolute Deviation (MAD)	82.625
Skewness	7.717538936
Sum	699820.2873
Variance	80499.16789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
86	9	0.3%
82	9	0.3%
88	8	0.3%
75	8	0.3%
60	8	0.3%
136	8	0.3%
130	7	0.2%
Other values (1962)	2881	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	910
Distinct (%)	30.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.49039145

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.666666667
median	13.6
Q3	22.03571429
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.36904762

Descriptive statistics

Standard deviation	15.4620774
Coefficient of variation (CV)	0.8840326672
Kurtosis	29.30304319
Mean	17.49039145
Median Absolute Deviation (MAD)	6.6
Skewness	3.434441407
Sum	51911.48183
Variance	239.0758377
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	43	1.4%
9	42	1.4%
16	41	1.4%
8	39	1.3%
17	37	1.2%
14	37	1.2%
7	36	1.2%
11	36	1.2%
5	34	1.1%
15	34	1.1%
Other values (900)	2589	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	q_invoices	q_items	q_products	avg_ticket	avg_recency_days	frequency	q_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.2100	372.0000	34.0000	1733.0000	297.0000	18.1522	35.5000	17.0000	40.0000	50.9706	0.6176
1	1	13047	3232.5900	56.0000	9.0000	1390.0000	171.0000	18.9040	27.2500	0.0283	35.0000	154.4444	11.6667
2	2	12583	6705.3800	2.0000	15.0000	5028.0000	232.0000	28.9025	23.1875	0.0403	50.0000	335.2000	7.6000
3	3	13748	948.2500	95.0000	5.0000	439.0000	28.0000	33.8661	92.6667	0.0179	0.0000	87.8000	4.8000
4	4	15100	876.0000	333.0000	3.0000	80.0000	3.0000	292.0000	8.6000	0.0732	22.0000	26.6667	0.3333
5	5	15291	4623.3000	25.0000	14.0000	2102.0000	102.0000	45.3265	23.2000	0.0401	29.0000	150.1429	4.3571
6	6	14688	5630.8700	7.0000	21.0000	3621.0000	327.0000	17.2198	18.3000	0.0572	399.0000	172.4286	7.0476
7	7	17809	5411.9100	16.0000	12.0000	2057.0000	61.0000	88.7198	35.7000	0.0335	41.0000	171.4167	3.8333
8	8	15311	60767.9000	0.0000	91.0000	38194.0000	2379.0000	25.5435	4.1444	0.2433	474.0000	419.7143	6.2308
9	9	16098	2005.6300	87.0000	7.0000	613.0000	67.0000	29.9348	47.6667	0.0244	0.0000	87.5714	4.8571

Last rows

	df_index	customer_id	gross_revenue	recency_days	q_invoices	q_items	q_products	avg_ticket	avg_recency_days	frequency	q_returns	avg_basket_size	avg_unique_basket_size
2958	5626	17727	1060.2500	15.0000	1.0000	645.0000	66.0000	16.0644	6.0000	1.0000	6.0000	645.0000	66.0000
2959	5636	17232	421.5200	2.0000	2.0000	203.0000	36.0000	11.7089	12.0000	0.1538	0.0000	101.5000	15.0000
2960	5637	17468	137.0000	10.0000	2.0000	116.0000	5.0000	27.4000	4.0000	0.4000	0.0000	58.0000	2.5000
2961	5648	13596	697.0400	5.0000	2.0000	406.0000	166.0000	4.1990	7.0000	0.2500	0.0000	203.0000	66.5000
2962	5654	14893	1237.8500	9.0000	2.0000	799.0000	73.0000	16.9568	2.0000	0.6667	0.0000	399.5000	36.0000
2963	5658	12479	473.2000	11.0000	1.0000	382.0000	30.0000	15.7733	4.0000	1.0000	34.0000	382.0000	30.0000
2964	5679	14126	706.1300	7.0000	3.0000	508.0000	15.0000	47.0753	3.0000	0.7500	50.0000	169.3333	4.6667
2965	5685	13521	1092.3900	1.0000	3.0000	733.0000	435.0000	2.5112	4.5000	0.3000	0.0000	244.3333	104.0000
2966	5695	15060	301.8400	8.0000	4.0000	262.0000	120.0000	2.5153	1.0000	2.0000	0.0000	65.5000	20.0000
2967	5714	12558	269.9600	7.0000	1.0000	196.0000	11.0000	24.5418	6.0000	1.0000	196.0000	196.0000	11.0000

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows